There seems to be some confusion here.
The Pg module and the DBI modules are NOT the same thing. The first is a
postgreSQL specific perl module. The second is an API; it has a standard
set of commands and these are applied to the database of your choice using
the appropriate driver (in this case DBD::Pg).
The fact that you mention use pg; (which by the way should be use Pg;)
implies you're trying to use the former. But if you've already installed
DBI/DBD::Pg, why not use these instead of the Pg module?
Try
perldoc DBI
perldoc DBD::Pg
for more info on these.
If you want to use Pg get and install the Pg module from CPAN and try
perldoc Pg
or recompile postgreSQL with the --with-perl switch.
oh, and to view the tables in a database
psql <database>
\dt
HTH,
S.
>I would like to use a perl-script together with postgresql. Therefore I have
>to use the following line:
>
>use pg;
>
>I know I have to install a DBD herefore, but where can I get it? I have
>installed DBD-pg-0.92, DBI-1.06 and postgresql-6.4.2.
>A second (short) question:
>How can I view the tables in a DB?
>Thanks in advance,
>
> Jeroen Hermans
> Webmaster HaFaBra.nl
> info@hafabra.nl
>
>____________________________________________
>
>De ideale LINK tussen muziek en internet:
>
>De Nationale HaFaBra-pagina, http://www.hafabra.nl
>
>Een must voor iedere muziekliefhebber!
>____________________________________________
+--------------------------+--------------------------------------+
| Stuart C. G. Rison | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street |
| N.B. new phone code!! | London, W1P 8BT |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM |
| Fax. +44 (0)207 878 4040 | stuart@ludwig.ucl.ac.uk |
+--------------------------+--------------------------------------+